MySQL Event Scheduler was added in MySQL 5.1.6. MySQL Events are tasks that run according to a schedule. Therefore, we sometimes refer to them as scheduled events. When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Conceptually, this is similar to the idea of the Windows Task Scheduler.
Just simply click to open an object pane for Event.
By using the object pane toolbar below,
you can create new, edit and delete the selected event.
Create Event
To create a new event
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Event from the popup menu.
- Edit event properties on the appropriate tabs of the Event Designer.
Hint: To create new event you can also control-click the Event node of the navigation pane and select New Event from the popup menu.
To create a new event with the same properties as one of the existing event has (using drag and drop method)
Apply to: current database {same connection}
- Select the event(s) for copying in the navigation pane/object pane.
- Click and drag the chosen event(s) to the target location.
- Select one of the following options:
- Copy
- Cancel
- The newly created event(s) will be named as "eventname_copy".
Apply to: different database {same connection} different database {different connection} (Data Transfer tool will be activated)
To create a new event with the same properties as one of the existing event has
- Select the event(s) for copying in the object pane.
- Drag and drop the chosen event(s) to the target database.
- Select one of the following options:
- Copy
- Cancel
- Control-click the event in the navigation pane or object pane and choose Duplicate Event.
- The newly created event will be named as "eventname_copy".
To create a new event with modification as one of the existing event
- Select the event for modifying in the navigation pane/object pane.
- Control-click and select Design
Event from the popup menu or simply double-click the event.
or - Click the
from the object pane toolbar.
- Modify event properties on the appropriate tabs of the Event Designer.
- Click
Save As.
To edit the existing event (manage its definition etc)
- Select the event for editing in the navigation pane/object pane.
- Control-click and select Design Event
from the popup menu or simply double-click the event.
or - Click the
from the object pane toolbar.
- Edit event properties on the appropriate tabs of the Event Designer.
To change the name of the event
- Select the event for editing in the navigation pane/object pane.
- Control-click and select the Rename from the popup menu.
Delete Event
To delete an event
- Select the event for deleting in the navigation pane/object pane.
- Control-click and select Delete Event
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Event Information
To achieve an event information
- Select the event in the navigation pane/object pane.
- Choose View -> Object Information in the main menu.
or - Click the
from the object pane toolbar.